USE [aspnetdb]
GO

-- =============================================
-- Author     :		Lohith Ram D V
-- Create date:         08/mar/2011
-- =============================================

create procedure sp_GetCheckOutDocument(
		@par_userid int)
AS
BEGIN
   
	SELECT [Document].[doc_title], [Doc_Checked].[doc_id]
	FROM [Document],[Doc_Checked]
	WHERE [Doc_Checked].user1_id = @par_userid and 
	[Document].[doc_id]=[Doc_Checked].[doc_id] 
	and [Doc_Checked].[checked]='true'
END
